My Stuff
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
-
Re: Item Receipt vs. PO Line Data Formula (Inventory Detail Status)
Hi @jmack_admin, Please try this formula using a Formula (Numeric) field with Summary Type = Maximum: MAX{appliedtotransaction.quantity} - SUM(CASE WHEN {inventorydetail.status} = 'Bad' THE…1 -
Re: Work order completion with backflush after inventory issue generates error
Hi @moonking, I did further tests on the scenario that you provided and I noted that once you issue the components, it does not show in the Committed column, but shows in the Used In Build column ins…1 -
Re: Inventory Counts Review
Hi there @Brad3987399, I checked my resources on this and found that it is not yet possible to export the Inventory Worksheet table data. There is an enhancement logged requesting for this ability: E…2 -
Re: Save search with calculating inventory aging formula question
Hi @Angel Chang, Here's my understanding of the logic that you mentioned: CASE WHEN {Ending Quantity} > {Less than 3 Months Inputs} THEN {Les than 3 Months Inputs} ELSE {Ending Quantity} END …1 -
Re: Saved search of last completed work order operation
Hi @Johnny Cash, I ran some tests on this, and I noticed that there is a Status field for the Manufacturing Operations. I think we can use this field in a formula to get the Min and Max value of the …1
